---
title: DB-CLL-010 — Insert a new appeal record
summary: Insert a new appeal record
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-010 — Insert a new appeal record

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-010 |
| Operation type | I |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsAppeal |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| AppealID | ReturnValue | NUMBER | N/A | New appeal identifier assigned on insert |
| LegalCaseID | Input | NUMBER | N/A | Owning legal case identifier |
| AppealDate | Input | DATE | N/A | Date the appeal was filed |
| AppealTypeCode | Input | VARCHAR2 | N/A | Type of appeal |
| FiledByCode | Input | VARCHAR2 | N/A | Code identifying who filed the appeal |
| ReviewLevelCode | Input | VARCHAR2 | N/A | Review level for the appeal |
| HearingLocationSeqNum | Input | NUMBER | N/A | Hearing location identifier |
| ScheduleDate | Input | DATE | N/A | Scheduled hearing/review date |
| DecisionDate | Input | DATE | N/A | Date a decision was rendered |
| DecisionCode | Input | VARCHAR2 | N/A | Decision outcome code |
| ExtensionDate | Input | DATE | N/A | Extension date, if granted |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [APPEAL](../database-tables.md#appeal) | INSERT | 19 columns (inferred*) |

## Sample SQL

```sql
EXEC pk80001_legalNet.insertAppeal(:AppealID OUT, :LegalCaseID, :AppealDate, :AppealTypeCode,
  :FiledByCode, :ReviewLevelCode, :HearingLocationSeqNum, :ScheduleDate, :DecisionDate,
  :DecisionCode, :ExtensionDate, :Comments, :CreateUser, :CreateDate,
  :SummaryText, :RequestTypeCode, :PetitionerRespondentCode, :UpdateUser, :UpdateDate);  -- final 5 params inferred from remaining appeal-detail columns*
```

## Operations and processes

- [Manage appeals and appeal extensions](../operations/manage-appeal.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb`